Iowa_Liquor_Sale

Dataset statistics

Number of variables	24
Number of observations	24847481
Missing cells	3611267
Missing cells (%)	0.6%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	21.0 GiB
Average record size in memory	908.3 B

Variable types

Text	9
DateTime	1
Numeric	12
Unsupported	2

Alerts

`Store Location` has 2450072 (9.9%) missing values	Missing
`County Number` has 714638 (2.9%) missing values	Missing
`Bottle Volume (ml)` is highly skewed (γ1 = 207.8010243)	Skewed
`State Bottle Cost` is highly skewed (γ1 = 183.009033)	Skewed
`State Bottle Retail` is highly skewed (γ1 = 183.0325335)	Skewed
`Bottles Sold` is highly skewed (γ1 = 65.3044445)	Skewed
`Sale (Dollars)` is highly skewed (γ1 = 88.29524725)	Skewed
`Volume Sold (Liters)` is highly skewed (γ1 = 65.33839987)	Skewed
`Volume Sold (Gallons)` is highly skewed (γ1 = 65.33652904)	Skewed
`Invoice/Item Number` has unique values	Unique
`Zip Code` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Item Number` is an unsupported type, check if it needs cleaning or further analysis	Unsupported

Reproduction

Analysis started	2024-08-09 23:59:51.990494
Analysis finished	2024-08-10 00:24:47.211526
Duration	24 minutes and 55.22 seconds
Software version	ydata-profiling vv4.9.0
Download configuration	config.json

Invoice/Item Number
Text

UNIQUE

Distinct	24847481
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	1.6 GiB

Length

Max length	16
Median length	15
Mean length	13.807005
Min length	9

Characters and Unicode

Total characters	343069303
Distinct characters	16
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	24847481 ?
Unique (%)	100.0%

Sample

1st row	INV-16589800035
2nd row	INV-16669000029
3rd row	INV-16624000064
4th row	INV-16610400055
5th row	INV-16575300022

Value	Count	Frequency (%)
inv-16639800026	1	< 0.1%
inv-16619600095	1	< 0.1%
inv-16589800035	1	< 0.1%
inv-16669000029	1	< 0.1%
inv-16624000064	1	< 0.1%
inv-16610400055	1	< 0.1%
inv-16575300022	1	< 0.1%
inv-16623300001	1	< 0.1%
inv-16615400044	1	< 0.1%
inv-16676400069	1	< 0.1%
Other values (24847471)	24847471	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
0	98476952	28.7%
1	29326157	8.5%
2	25533278	7.4%
3	22064596	6.4%
4	19126161	5.6%
5	16856716	4.9%
6	16030662	4.7%
7	15555848	4.5%
8	15283674	4.5%
9	15069782	4.4%
Other values (6)	69745477	20.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	343069303	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	98476952	28.7%
1	29326157	8.5%
2	25533278	7.4%
3	22064596	6.4%
4	19126161	5.6%
5	16856716	4.9%
6	16030662	4.7%
7	15555848	4.5%
8	15283674	4.5%
9	15069782	4.4%
Other values (6)	69745477	20.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	343069303	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	98476952	28.7%
1	29326157	8.5%
2	25533278	7.4%
3	22064596	6.4%
4	19126161	5.6%
5	16856716	4.9%
6	16030662	4.7%
7	15555848	4.5%
8	15283674	4.5%
9	15069782	4.4%
Other values (6)	69745477	20.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	343069303	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	98476952	28.7%
1	29326157	8.5%
2	25533278	7.4%
3	22064596	6.4%
4	19126161	5.6%
5	16856716	4.9%
6	16030662	4.7%
7	15555848	4.5%
8	15283674	4.5%
9	15069782	4.4%
Other values (6)	69745477	20.3%

Date
Date

Distinct	2730
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	189.6 MiB

Minimum	2012-01-03 00:00:00
Maximum	2022-09-30 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

Store Number
Real number (ℝ)

Distinct	2807
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3786.0345

Minimum	2106
Maximum	10057
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	189.6 MiB

Quantile statistics

Minimum	2106
5-th percentile	2506
Q1	2619
median	3829
Q3	4642
95-th percentile	5600
Maximum	10057
Range	7951
Interquartile range (IQR)	2023

Descriptive statistics

Standard deviation	1104.2915
Coefficient of variation (CV)	0.29167497
Kurtosis	-0.59070345
Mean	3786.0345
Median Absolute Deviation (MAD)	1172
Skewness	0.34019531
Sum	9.4073421 × 10¹⁰
Variance	1219459.8
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2633	205995	0.8%
4829	173686	0.7%
2190	163078	0.7%
2512	139260	0.6%
2572	131220	0.5%
2603	128754	0.5%
2515	124798	0.5%
2614	124479	0.5%
2647	120373	0.5%
2648	119680	0.5%
Other values (2797)	23416158	94.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2106	46159	0.2%
2113	11419	< 0.1%
2130	39072	0.2%
2132	535	< 0.1%
2152	6649	< 0.1%
2161	566	< 0.1%
2178	23290	0.1%
2190	163078	0.7%
2191	60926	0.2%
2200	39148	0.2%

Value	Count	Frequency (%)
10057	144	< 0.1%
10053	87	< 0.1%
10051	121	< 0.1%
10046	84	< 0.1%
10045	260	< 0.1%
10044	35	< 0.1%
10042	162	< 0.1%
10040	56	< 0.1%
10039	1610	< 0.1%
10037	694	< 0.1%

Store Name
Text

Distinct	2972
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.9 GiB

Length

Max length	58
Median length	42
Mean length	26.158078
Min length	4

Characters and Unicode

Total characters	649962354
Distinct characters	75
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3 ?
Unique (%)	< 0.1%

Sample

1st row	Hy-Vee Food Store / Oskaloosa
2nd row	Stewart Road Fast Break
3rd row	Hy-Vee Food Store / Carroll
4th row	Fareway Stores #909 / Ankeny
5th row	Big G Food Store

Value	Count	Frequency (%)
	19402342	16.1%
hy-vee	8172944	6.8%
store	5547356	4.6%
food	4809433	4.0%
and	3561175	3.0%
liquor	3178494	2.6%
spirits	2590565	2.1%
wine	2188822	1.8%
city	2006216	1.7%
cedar	1472216	1.2%
Other values (2548)	67614587	56.1%

Most occurring characters

Value	Count	Frequency (%)
	96494134	14.8%
e	56030548	8.6%
o	44093308	6.8%
r	36054932	5.5%
a	31534722	4.9%
t	28479887	4.4%
i	27187115	4.2%
n	23026225	3.5%
s	21045699	3.2%
/	17502571	2.7%
Other values (65)	268513213	41.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	649962354	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	96494134	14.8%
e	56030548	8.6%
o	44093308	6.8%
r	36054932	5.5%
a	31534722	4.9%
t	28479887	4.4%
i	27187115	4.2%
n	23026225	3.5%
s	21045699	3.2%
/	17502571	2.7%
Other values (65)	268513213	41.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	649962354	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	96494134	14.8%
e	56030548	8.6%
o	44093308	6.8%
r	36054932	5.5%
a	31534722	4.9%
t	28479887	4.4%
i	27187115	4.2%
n	23026225	3.5%
s	21045699	3.2%
/	17502571	2.7%
Other values (65)	268513213	41.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	649962354	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	96494134	14.8%
e	56030548	8.6%
o	44093308	6.8%
r	36054932	5.5%
a	31534722	4.9%
t	28479887	4.4%
i	27187115	4.2%
n	23026225	3.5%
s	21045699	3.2%
/	17502571	2.7%
Other values (65)	268513213	41.3%

Address
Text

Distinct	4134
Distinct (%)	< 0.1%
Missing	81913
Missing (%)	0.3%
Memory size	1.7 GiB

Length

Max length	55
Median length	32
Mean length	15.851496
Min length	8

Characters and Unicode

Total characters	392571292
Distinct characters	70
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3 ?
Unique (%)	< 0.1%

Sample

1st row	110 S D St
2nd row	2418 Stewart Rd
3rd row	905 US Highway 30 West
4th row	109 SE Oralabor Rd
5th row	Po Box 261 310 W Dillon

Value	Count	Frequency (%)
st	8593247	9.7%
ave	5173259	5.8%
e	2034123	2.3%
rd	2032702	2.3%
w	1811805	2.0%
s	1496868	1.7%
n	1483308	1.7%
dr	1467716	1.7%
se	1231645	1.4%
main	1210111	1.4%
Other values (1894)	62112033	70.1%

Most occurring characters

Value	Count	Frequency (%)
	66158967	16.9%
1	23363309	6.0%
0	18649626	4.8%
S	18056666	4.6%
t	14873854	3.8%
2	13310956	3.4%
E	12815806	3.3%
e	12453780	3.2%
A	11632097	3.0%
5	9692813	2.5%
Other values (60)	191563418	48.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	392571292	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	66158967	16.9%
1	23363309	6.0%
0	18649626	4.8%
S	18056666	4.6%
t	14873854	3.8%
2	13310956	3.4%
E	12815806	3.3%
e	12453780	3.2%
A	11632097	3.0%
5	9692813	2.5%
Other values (60)	191563418	48.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	392571292	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	66158967	16.9%
1	23363309	6.0%
0	18649626	4.8%
S	18056666	4.6%
t	14873854	3.8%
2	13310956	3.4%
E	12815806	3.3%
e	12453780	3.2%
A	11632097	3.0%
5	9692813	2.5%
Other values (60)	191563418	48.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	392571292	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	66158967	16.9%
1	23363309	6.0%
0	18649626	4.8%
S	18056666	4.6%
t	14873854	3.8%
2	13310956	3.4%
E	12815806	3.3%
e	12453780	3.2%
A	11632097	3.0%
5	9692813	2.5%
Other values (60)	191563418	48.8%

City
Text

Distinct	859
Distinct (%)	< 0.1%
Missing	81912
Missing (%)	0.3%
Memory size	1.5 GiB

Length

Max length	17
Median length	15
Mean length	9.1979476
Min length	3

Characters and Unicode

Total characters	227792406
Distinct characters	56
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	Oskaloosa
2nd row	Muscatine
3rd row	Carroll
4th row	Ankeny
5th row	Marengo

Value	Count	Frequency (%)
des	2845492	7.9%
moines	2845492	7.9%
city	2202300	6.1%
cedar	2110848	5.8%
rapids	1681705	4.7%
davenport	1066185	3.0%
west	865098	2.4%
sioux	791761	2.2%
waterloo	780243	2.2%
iowa	763989	2.1%
Other values (482)	20176657	55.8%

Most occurring characters

Value	Count	Frequency (%)
e	14916536	6.5%
	11364201	5.0%
o	11147155	4.9%
a	10607823	4.7%
n	10011793	4.4%
s	9316873	4.1%
E	9007701	4.0%
i	8963399	3.9%
A	8122206	3.6%
C	7904330	3.5%
Other values (46)	126430389	55.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	227792406	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	14916536	6.5%
	11364201	5.0%
o	11147155	4.9%
a	10607823	4.7%
n	10011793	4.4%
s	9316873	4.1%
E	9007701	4.0%
i	8963399	3.9%
A	8122206	3.6%
C	7904330	3.5%
Other values (46)	126430389	55.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	227792406	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	14916536	6.5%
	11364201	5.0%
o	11147155	4.9%
a	10607823	4.7%
n	10011793	4.4%
s	9316873	4.1%
E	9007701	4.0%
i	8963399	3.9%
A	8122206	3.6%
C	7904330	3.5%
Other values (46)	126430389	55.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	227792406	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	14916536	6.5%
	11364201	5.0%
o	11147155	4.9%
a	10607823	4.7%
n	10011793	4.4%
s	9316873	4.1%
E	9007701	4.0%
i	8963399	3.9%
A	8122206	3.6%
C	7904330	3.5%
Other values (46)	126430389	55.5%

Zip Code
Unsupported

REJECTED UNSUPPORTED

Missing	81957
Missing (%)	0.3%
Memory size	1.1 GiB

Store Location
Text

MISSING

Distinct	3203
Distinct (%)	< 0.1%
Missing	2450072
Missing (%)	9.9%
Memory size	1.9 GiB

Length

Max length	45
Median length	28
Mean length	28.848594
Min length	23

Characters and Unicode

Total characters	646133761
Distinct characters	20
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	9 ?
Unique (%)	< 0.1%

Sample

1st row	POINT (-92.649764 41.295218)
2nd row	POINT (-91.07265200000002 41.390911)
3rd row	POINT (-94.853591 42.064155)
4th row	POINT (-93.59949600000002 41.702811)
5th row	POINT (-94.377667 42.026833)

Value	Count	Frequency (%)
point	22397409	33.3%
93.596754	189532	0.3%
41.554101	189532	0.3%
93.613739	155441	0.2%
41.60572	155441	0.2%
93.619787	151647	0.2%
41.60566	151647	0.2%
42.512789	131216	0.2%
92.435236	131216	0.2%
91.53046300000001	131200	0.2%
Other values (5932)	43407946	64.6%

Most occurring characters

Value	Count	Frequency (%)
4	50476897	7.8%
0	47062048	7.3%
9	46185792	7.1%
1	45904070	7.1%
.	44794818	6.9%
	44794818	6.9%
2	35257191	5.5%
3	34526189	5.3%
5	33797112	5.2%
6	31973632	4.9%
Other values (10)	231361194	35.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	646133761	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
4	50476897	7.8%
0	47062048	7.3%
9	46185792	7.1%
1	45904070	7.1%
.	44794818	6.9%
	44794818	6.9%
2	35257191	5.5%
3	34526189	5.3%
5	33797112	5.2%
6	31973632	4.9%
Other values (10)	231361194	35.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	646133761	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
4	50476897	7.8%
0	47062048	7.3%
9	46185792	7.1%
1	45904070	7.1%
.	44794818	6.9%
	44794818	6.9%
2	35257191	5.5%
3	34526189	5.3%
5	33797112	5.2%
6	31973632	4.9%
Other values (10)	231361194	35.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	646133761	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
4	50476897	7.8%
0	47062048	7.3%
9	46185792	7.1%
1	45904070	7.1%
.	44794818	6.9%
	44794818	6.9%
2	35257191	5.5%
3	34526189	5.3%
5	33797112	5.2%
6	31973632	4.9%
Other values (10)	231361194	35.8%

County Number
Real number (ℝ)

MISSING

Distinct	99
Distinct (%)	< 0.1%
Missing	714638
Missing (%)	2.9%
Infinite	0
Infinite (%)	0.0%
Mean	57.259133

Minimum	1
Maximum	99
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	189.6 MiB

Quantile statistics

Minimum	1
5-th percentile	7
Q1	31
median	62
Q3	77
95-th percentile	94
Maximum	99
Range	98
Interquartile range (IQR)	46

Descriptive statistics

Standard deviation	27.287104
Coefficient of variation (CV)	0.47655462
Kurtosis	-0.94931404
Mean	57.259133
Median Absolute Deviation (MAD)	17
Skewness	-0.53944166
Sum	1.3818257 × 10⁹
Variance	744.58607
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
77	4459618	17.9%
57	2013416	8.1%
82	1472224	5.9%
7	1353303	5.4%
52	1210494	4.9%
78	796208	3.2%
85	771807	3.1%
97	755174	3.0%
31	701537	2.8%
17	533730	2.1%
Other values (89)	10065332	40.5%
(Missing)	714638	2.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	50009	0.2%
2	19865	0.1%
3	99368	0.4%
4	86089	0.3%
5	26544	0.1%
6	114142	0.5%
7	1353303	5.4%
8	173668	0.7%
9	187794	0.8%
10	135565	0.5%

Value	Count	Frequency (%)
99	69415	0.3%
98	34253	0.1%
97	755174	3.0%
96	122996	0.5%
95	83972	0.3%
94	274118	1.1%
93	18725	0.1%
92	147811	0.6%
91	222011	0.9%
90	278134	1.1%

County
Text

Distinct	201
Distinct (%)	< 0.1%
Missing	158715
Missing (%)	0.6%
Memory size	1.5 GiB

Length

Max length	13
Median length	10
Mean length	6.3615352
Min length	3

Characters and Unicode

Total characters	157058455
Distinct characters	51
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	MAHASKA
2nd row	MUSCATINE
3rd row	CARROLL
4th row	POLK
5th row	IOWA

Value	Count	Frequency (%)
polk	4568617	16.7%
linn	2059315	7.5%
scott	1502782	5.5%
black	1383941	5.1%
hawk	1383941	5.1%
johnson	1236666	4.5%
story	788339	2.9%
woodbury	771923	2.8%
dubuque	715855	2.6%
cerro	544520	2.0%
Other values (101)	12370083	45.3%

Most occurring characters

Value	Count	Frequency (%)
O	10932567	7.0%
L	8394015	5.3%
o	8103942	5.2%
N	7764016	4.9%
A	7578533	4.8%
P	6332829	4.0%
S	6138724	3.9%
T	5925866	3.8%
n	5369048	3.4%
K	5216964	3.3%
Other values (41)	85301951	54.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	157058455	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
O	10932567	7.0%
L	8394015	5.3%
o	8103942	5.2%
N	7764016	4.9%
A	7578533	4.8%
P	6332829	4.0%
S	6138724	3.9%
T	5925866	3.8%
n	5369048	3.4%
K	5216964	3.3%
Other values (41)	85301951	54.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	157058455	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
O	10932567	7.0%
L	8394015	5.3%
o	8103942	5.2%
N	7764016	4.9%
A	7578533	4.8%
P	6332829	4.0%
S	6138724	3.9%
T	5925866	3.8%
n	5369048	3.4%
K	5216964	3.3%
Other values (41)	85301951	54.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	157058455	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
O	10932567	7.0%
L	8394015	5.3%
o	8103942	5.2%
N	7764016	4.9%
A	7578533	4.8%
P	6332829	4.0%
S	6138724	3.9%
T	5925866	3.8%
n	5369048	3.4%
K	5216964	3.3%
Other values (41)	85301951	54.3%

Category
Real number (ℝ)

Distinct	114
Distinct (%)	< 0.1%
Missing	16974
Missing (%)	0.1%
Infinite	0
Infinite (%)	0.0%
Mean	1049080.2

Minimum	101220
Maximum	1901200
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	189.6 MiB

Quantile statistics

Minimum	101220
5-th percentile	1011200
Q1	1012200
median	1031200
Q3	1062400
95-th percentile	1082000
Maximum	1901200
Range	1799980
Interquartile range (IQR)	50200

Descriptive statistics

Standard deviation	78245.098
Coefficient of variation (CV)	0.074584478
Kurtosis	64.802301
Mean	1049080.2
Median Absolute Deviation (MAD)	19810
Skewness	7.6585159
Sum	2.6049193 × 10¹³
Variance	6.1222953 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1012100	2376643	9.6%
1031100	2337813	9.4%
1011200	1537217	6.2%
1031080	1265974	5.1%
1031200	1236935	5.0%
1081600	1095653	4.4%
1011100	1070908	4.3%
1022100	758381	3.1%
1062200	739758	3.0%
1062400	704020	2.8%
Other values (104)	11707205	47.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
101220	6	< 0.1%
1011000	1	< 0.1%
1011100	1070908	4.3%
1011200	1537217	6.2%
1011250	9268	< 0.1%
1011300	267674	1.1%
1011400	417493	1.7%
1011500	77896	0.3%
1011600	110947	0.4%
1011700	10223	< 0.1%

Value	Count	Frequency (%)
1901200	28045	0.1%
1901100	63	< 0.1%
1901000	423	< 0.1%
1900000	1	< 0.1%
1701200	48	< 0.1%
1701100	247903	1.0%
1700000	17944	0.1%
1501100	32	< 0.1%
1101100	24351	0.1%
1092100	20473	0.1%

Category Name
Text

Distinct	136
Distinct (%)	< 0.1%
Missing	25040
Missing (%)	0.1%
Memory size	1.7 GiB

Length

Max length	36
Median length	34
Mean length	17.324517
Min length	6

Characters and Unicode

Total characters	430036803
Distinct characters	58
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	< 0.1%

Sample

1st row	Straight Rye Whiskies
2nd row	Imported Schnapps
3rd row	Single Barrel Bourbon Whiskies
4th row	Temporary & Specialty Packages
5th row	Straight Rye Whiskies

Value	Count	Frequency (%)
whiskies	6559168	10.8%
american	5592758	9.2%
vodka	3557828	5.8%
imported	3191448	5.2%
rum	2780252	4.6%
vodkas	2724570	4.5%
canadian	2376643	3.9%
flavored	2256480	3.7%
	1999419	3.3%
straight	1707281	2.8%
Other values (100)	28162235	46.2%

Most occurring characters

Value	Count	Frequency (%)
	36107834	8.4%
i	23566038	5.5%
e	22403455	5.2%
a	20761269	4.8%
I	18042114	4.2%
A	17967391	4.2%
s	16752032	3.9%
S	16400073	3.8%
r	15293605	3.6%
R	14051712	3.3%
Other values (48)	228691280	53.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	430036803	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	36107834	8.4%
i	23566038	5.5%
e	22403455	5.2%
a	20761269	4.8%
I	18042114	4.2%
A	17967391	4.2%
s	16752032	3.9%
S	16400073	3.8%
r	15293605	3.6%
R	14051712	3.3%
Other values (48)	228691280	53.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	430036803	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	36107834	8.4%
i	23566038	5.5%
e	22403455	5.2%
a	20761269	4.8%
I	18042114	4.2%
A	17967391	4.2%
s	16752032	3.9%
S	16400073	3.8%
r	15293605	3.6%
R	14051712	3.3%
Other values (48)	228691280	53.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	430036803	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	36107834	8.4%
i	23566038	5.5%
e	22403455	5.2%
a	20761269	4.8%
I	18042114	4.2%
A	17967391	4.2%
s	16752032	3.9%
S	16400073	3.8%
r	15293605	3.6%
R	14051712	3.3%
Other values (48)	228691280	53.2%

Vendor Number
Real number (ℝ)

Distinct	428
Distinct (%)	< 0.1%
Missing	9
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	266.71765

Minimum	10
Maximum	987
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	189.6 MiB

Quantile statistics

Minimum	10
5-th percentile	55
Q1	115
median	260
Q3	391
95-th percentile	434
Maximum	987
Range	977
Interquartile range (IQR)	276

Descriptive statistics

Standard deviation	141.89777
Coefficient of variation (CV)	0.53201494
Kurtosis	-0.034845742
Mean	266.71765
Median Absolute Deviation (MAD)	135
Skewness	0.022030204
Sum	6.6272593 × 10⁹
Variance	20134.978
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
260	4127854	16.6%
65	2307531	9.3%
434	2206741	8.9%
421	1918825	7.7%
370	1474144	5.9%
259	1278543	5.1%
35	1106048	4.5%
115	1044480	4.2%
55	1040215	4.2%
395	960804	3.9%
Other values (418)	7382287	29.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
10	1003	< 0.1%
14	1	< 0.1%
27	3	< 0.1%
33	23	< 0.1%
35	1106048	4.5%
51	1	< 0.1%
55	1040215	4.2%
61	11	< 0.1%
65	2307531	9.3%
68	1	< 0.1%

Value	Count	Frequency (%)
987	31	< 0.1%
978	11891	< 0.1%
977	598	< 0.1%
971	15858	0.1%
969	1565	< 0.1%
962	3029	< 0.1%
892	5	< 0.1%
890	1	< 0.1%
888	401	< 0.1%
886	1133	< 0.1%

Vendor Name
Text

Distinct	585
Distinct (%)	< 0.1%
Missing	7
Missing (%)	< 0.1%
Memory size	1.7 GiB

Length

Max length	67
Median length	57
Mean length	17.958747
Min length	7

Characters and Unicode

Total characters	446229506
Distinct characters	71
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	49 ?
Unique (%)	< 0.1%

Sample

1st row	Infinium Spirits
2nd row	SAZERAC COMPANY INC
3rd row	Heaven Hill Brands
4th row	DIAGEO AMERICAS
5th row	Infinium Spirits

Value	Count	Frequency (%)
inc	6432419	9.3%
brands	4128875	5.9%
americas	4128257	5.9%
diageo	4127854	5.9%
company	3495628	5.0%
sazerac	2959040	4.3%
jim	2307531	3.3%
beam	2307531	3.3%
usa	2009414	2.9%
pernod	1474144	2.1%
Other values (715)	36031084	51.9%

Most occurring characters

Value	Count	Frequency (%)
	46468880	10.4%
A	24969779	5.6%
a	22762692	5.1%
i	22639415	5.1%
C	19673973	4.4%
r	18469298	4.1%
n	18328273	4.1%
e	17600154	3.9%
I	16960889	3.8%
o	16726088	3.7%
Other values (61)	221630065	49.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	446229506	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	46468880	10.4%
A	24969779	5.6%
a	22762692	5.1%
i	22639415	5.1%
C	19673973	4.4%
r	18469298	4.1%
n	18328273	4.1%
e	17600154	3.9%
I	16960889	3.8%
o	16726088	3.7%
Other values (61)	221630065	49.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	446229506	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	46468880	10.4%
A	24969779	5.6%
a	22762692	5.1%
i	22639415	5.1%
C	19673973	4.4%
r	18469298	4.1%
n	18328273	4.1%
e	17600154	3.9%
I	16960889	3.8%
o	16726088	3.7%
Other values (61)	221630065	49.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	446229506	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	46468880	10.4%
A	24969779	5.6%
a	22762692	5.1%
i	22639415	5.1%
C	19673973	4.4%
r	18469298	4.1%
n	18328273	4.1%
e	17600154	3.9%
I	16960889	3.8%
o	16726088	3.7%
Other values (61)	221630065	49.7%

Item Number
Unsupported

REJECTED UNSUPPORTED

Missing	0
Missing (%)	0.0%
Memory size	854.7 MiB

Item Description
Text

Distinct	10911
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.8 GiB

Length

Max length	63
Median length	52
Mean length	20.979921
Min length	2

Characters and Unicode

Total characters	521298190
Distinct characters	87
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1137 ?
Unique (%)	< 0.1%

Sample

1st row	Templeton 4YR Rye
2nd row	Dr McGillicuddys Cherry
3rd row	Evan Williams Vintage
4th row	Smirnoff Peppermint Twist
5th row	Templeton Rye Rare Cask Strength

Value	Count	Frequency (%)
vodka	4457394	5.4%
mini	1995067	2.4%
rum	1794303	2.2%
black	1688907	2.1%
whiskey	1375358	1.7%
spiced	1197714	1.5%
crown	1126861	1.4%
pet	1086395	1.3%
velvet	971338	1.2%
liqueur	880339	1.1%
Other values (5103)	65447005	79.8%

Most occurring characters

Value	Count	Frequency (%)
	57181604	11.0%
a	42706416	8.2%
e	41239590	7.9%
i	31446331	6.0%
r	31154241	6.0%
o	27157260	5.2%
n	26456014	5.1%
l	21490373	4.1%
s	16448032	3.2%
d	15303158	2.9%
Other values (77)	210715171	40.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	521298190	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	57181604	11.0%
a	42706416	8.2%
e	41239590	7.9%
i	31446331	6.0%
r	31154241	6.0%
o	27157260	5.2%
n	26456014	5.1%
l	21490373	4.1%
s	16448032	3.2%
d	15303158	2.9%
Other values (77)	210715171	40.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	521298190	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	57181604	11.0%
a	42706416	8.2%
e	41239590	7.9%
i	31446331	6.0%
r	31154241	6.0%
o	27157260	5.2%
n	26456014	5.1%
l	21490373	4.1%
s	16448032	3.2%
d	15303158	2.9%
Other values (77)	210715171	40.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	521298190	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	57181604	11.0%
a	42706416	8.2%
e	41239590	7.9%
i	31446331	6.0%
r	31154241	6.0%
o	27157260	5.2%
n	26456014	5.1%
l	21490373	4.1%
s	16448032	3.2%
d	15303158	2.9%
Other values (77)	210715171	40.4%

Pack
Real number (ℝ)

Distinct	28
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	12.204653

Minimum	1
Maximum	336
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	189.6 MiB

Quantile statistics

Minimum	1
5-th percentile	6
Q1	6
median	12
Q3	12
95-th percentile	24
Maximum	336
Range	335
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	7.7094335
Coefficient of variation (CV)	0.63167985
Kurtosis	21.924377
Mean	12.204653
Median Absolute Deviation (MAD)	0
Skewness	3.122434
Sum	3.0325489 × 10⁸
Variance	59.435364
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=28)

Value	Count	Frequency (%)
12	14108264	56.8%
6	6929906	27.9%
24	2251084	9.1%
48	625906	2.5%
10	490828	2.0%
1	193894	0.8%
8	76740	0.3%
5	57258	0.2%
44	41927	0.2%
4	35532	0.1%
Other values (18)	36142	0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	193894	0.8%
2	645	< 0.1%
3	27025	0.1%
4	35532	0.1%
5	57258	0.2%
6	6929906	27.9%
8	76740	0.3%
9	2050	< 0.1%
10	490828	2.0%
12	14108264	56.8%

Value	Count	Frequency (%)
336	13	< 0.1%
312	40	< 0.1%
288	101	< 0.1%
160	4	< 0.1%
120	5	< 0.1%
96	1	< 0.1%
80	9	< 0.1%
60	1265	< 0.1%
48	625906	2.5%
44	41927	0.2%

Bottle Volume (ml)
Real number (ℝ)

SKEWED

Distinct	58
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	892.22323

Minimum	0
Maximum	378000
Zeros	10
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	189.6 MiB

Quantile statistics

Minimum	0
5-th percentile	200
Q1	750
median	750
Q3	1000
95-th percentile	1750
Maximum	378000
Range	378000
Interquartile range (IQR)	250

Descriptive statistics

Standard deviation	639.17426
Coefficient of variation (CV)	0.7163838
Kurtosis	119468.83
Mean	892.22323
Median Absolute Deviation (MAD)	250
Skewness	207.80102
Sum	2.21695 × 10¹⁰
Variance	408543.74
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
750	11153324	44.9%
1750	4903124	19.7%
1000	3105652	12.5%
375	2544998	10.2%
200	879922	3.5%
50	865857	3.5%
500	730575	2.9%
600	221220	0.9%
100	175941	0.7%
3000	95623	0.4%
Other values (48)	171245	0.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	10	< 0.1%
12	1	< 0.1%
15	1	< 0.1%
20	1920	< 0.1%
25	253	< 0.1%
50	865857	3.5%
100	175941	0.7%
150	793	< 0.1%
175	54	< 0.1%
200	879922	3.5%

Value	Count	Frequency (%)
378000	24	< 0.1%
225000	1	< 0.1%
189000	2	< 0.1%
180000	2	< 0.1%
140000	8	< 0.1%
31500	24	< 0.1%
9000	3	< 0.1%
7580	1	< 0.1%
6000	1299	< 0.1%
5250	194	< 0.1%

State Bottle Cost
Real number (ℝ)

SKEWED

Distinct	3377
Distinct (%)	< 0.1%
Missing	10
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	10.265363

Minimum	0
Maximum	7680
Zeros	3084
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	189.6 MiB

Quantile statistics

Minimum	0
5-th percentile	2.96
Q1	5.52
median	8.25
Q3	12.5
95-th percentile	23.48
Maximum	7680
Range	7680
Interquartile range (IQR)	6.98

Descriptive statistics

Standard deviation	11.043744
Coefficient of variation (CV)	1.075826
Kurtosis	83951.321
Mean	10.265363
Median Absolute Deviation (MAD)	3.24
Skewness	183.00903
Sum	2.5506831 × 10⁸
Variance	121.96429
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
8.25	493597	2.0%
7.5	442179	1.8%
10	422000	1.7%
6.5	411121	1.7%
5	332540	1.3%
11	268716	1.1%
8	257565	1.0%
7	255836	1.0%
3.5	254111	1.0%
6	248874	1.0%
Other values (3367)	21460932	86.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	3084	< 0.1%
0.19	1	< 0.1%
0.33	15	< 0.1%
0.43	7	< 0.1%
0.48	1	< 0.1%
0.51	1	< 0.1%
0.55	1	< 0.1%
0.59	1	< 0.1%
0.66	2	< 0.1%
0.89	18060	0.1%

Value	Count	Frequency (%)
7680	1	< 0.1%
6468	2	< 0.1%
6100	2	< 0.1%
6000	4	< 0.1%
5800	9	< 0.1%
5500	1	< 0.1%
3537.3	24	< 0.1%
2298.84	1	< 0.1%
2250	11	< 0.1%
2249.97	1	< 0.1%

State Bottle Retail
Real number (ℝ)

SKEWED

Distinct	3846
Distinct (%)	< 0.1%
Missing	10
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	15.409941

Minimum	0
Maximum	11520
Zeros	3084
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	189.6 MiB

Quantile statistics

Minimum	0
5-th percentile	4.44
Q1	8.31
median	12.38
Q3	18.75
95-th percentile	35.22
Maximum	11520
Range	11520
Interquartile range (IQR)	10.44

Descriptive statistics

Standard deviation	16.564842
Coefficient of variation (CV)	1.0749452
Kurtosis	83966.495
Mean	15.409941
Median Absolute Deviation (MAD)	4.86
Skewness	183.03253
Sum	3.8289807 × 10⁸
Variance	274.39399
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
12.38	440414	1.8%
11.25	416848	1.7%
15	393457	1.6%
9.75	357595	1.4%
7.5	322103	1.3%
12	253615	1.0%
5.25	249031	1.0%
16.5	246789	1.0%
10.5	242173	1.0%
13.5	233326	0.9%
Other values (3836)	21692120	87.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	3084	< 0.1%
0.29	1	< 0.1%
0.5	15	< 0.1%
0.65	7	< 0.1%
0.72	1	< 0.1%
0.76	1	< 0.1%
0.83	1	< 0.1%
0.88	1	< 0.1%
0.99	2	< 0.1%
1.34	18060	0.1%

Value	Count	Frequency (%)
11520	1	< 0.1%
9702	2	< 0.1%
9150	2	< 0.1%
9000	4	< 0.1%
8700	9	< 0.1%
8250	1	< 0.1%
5305.95	24	< 0.1%
3448.26	1	< 0.1%
3375	11	< 0.1%
3374.96	1	< 0.1%

Bottles Sold
Real number (ℝ)

SKEWED

Distinct	692
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	10.636772

Minimum	-240
Maximum	15000
Zeros	9
Zeros (%)	< 0.1%
Negative	400
Negative (%)	< 0.1%
Memory size	189.6 MiB

Quantile statistics

Minimum	-240
5-th percentile	1
Q1	3
median	6
Q3	12
95-th percentile	24
Maximum	15000
Range	15240
Interquartile range (IQR)	9

Descriptive statistics

Standard deviation	29.505095
Coefficient of variation (CV)	2.7738768
Kurtosis	18435.701
Mean	10.636772
Median Absolute Deviation (MAD)	4
Skewness	65.304444
Sum	2.6429699 × 10⁸
Variance	870.55063
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
12	6570629	26.4%
6	5051881	20.3%
2	3238769	13.0%
1	2771696	11.2%
3	2423744	9.8%
24	1429527	5.8%
4	1335652	5.4%
48	389102	1.6%
5	311554	1.3%
36	202301	0.8%
Other values (682)	1122626	4.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-240	1	< 0.1%
-156	1	< 0.1%
-120	1	< 0.1%
-72	2	< 0.1%
-60	2	< 0.1%
-48	14	< 0.1%
-36	7	< 0.1%
-30	4	< 0.1%
-24	33	< 0.1%
-18	5	< 0.1%

Value	Count	Frequency (%)
15000	2	< 0.1%
13200	4	< 0.1%
11952	1	< 0.1%
11880	1	< 0.1%
11124	1	< 0.1%
7920	4	< 0.1%
7632	1	< 0.1%
7260	1	< 0.1%
7116	1	< 0.1%
6750	1	< 0.1%

Sale (Dollars)
Real number (ℝ)

SKEWED

Distinct	31523
Distinct (%)	0.1%
Missing	10
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	140.81338

Minimum	-3375
Maximum	279557.28
Zeros	4943
Zeros (%)	< 0.1%
Negative	400
Negative (%)	< 0.1%
Memory size	189.6 MiB

Quantile statistics

Minimum	-3375
5-th percentile	11.14
Q1	33.6
median	74.28
Q3	147.6
95-th percentile	342.24
Maximum	279557.28
Range	282932.28
Interquartile range (IQR)	114

Descriptive statistics

Standard deviation	489.26328
Coefficient of variation (CV)	3.4745511
Kurtosis	30136.114
Mean	140.81338
Median Absolute Deviation (MAD)	49.47
Skewness	88.295247
Sum	3.4988563 × 10⁹
Variance	239378.56
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
90	270962	1.1%
135	224866	0.9%
162	181797	0.7%
148.56	181670	0.7%
180	177391	0.7%
64.8	174545	0.7%
45	163792	0.7%
126	148000	0.6%
94.2	135410	0.5%
72	132935	0.5%
Other values (31513)	23056103	92.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-3375	1	< 0.1%
-1656	1	< 0.1%
-1439.52	1	< 0.1%
-1394.7	1	< 0.1%
-1348.8	1	< 0.1%
-1170	1	< 0.1%
-1124.4	1	< 0.1%
-1080	1	< 0.1%
-972	1	< 0.1%
-890.64	1	< 0.1%

Value	Count	Frequency (%)
279557.28	1	< 0.1%
254100	2	< 0.1%
250932	4	< 0.1%
225838.8	1	< 0.1%
196004.88	1	< 0.1%
181962	1	< 0.1%
156807	1	< 0.1%
150559.2	4	< 0.1%
145084.32	1	< 0.1%
130416	1	< 0.1%

Volume Sold (Liters)
Real number (ℝ)

SKEWED

Distinct	1577
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9.1722439

Minimum	-156
Maximum	15000
Zeros	10
Zeros (%)	< 0.1%
Negative	400
Negative (%)	< 0.1%
Memory size	189.6 MiB

Quantile statistics

Minimum	-156
5-th percentile	0.5
Q1	1.5
median	4.8
Q3	10.5
95-th percentile	21
Maximum	15000
Range	15156
Interquartile range (IQR)	9

Descriptive statistics

Standard deviation	35.311108
Coefficient of variation (CV)	3.8497786
Kurtosis	12528.506
Mean	9.1722439
Median Absolute Deviation (MAD)	4.2
Skewness	65.3384
Sum	2.2790716 × 10⁸
Variance	1246.8744
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
9	4812300	19.4%
10.5	3207479	12.9%
1.5	2048460	8.2%
2.25	1720122	6.9%
4.5	1511527	6.1%
0.75	1482309	6.0%
12	1456459	5.9%
3	1147574	4.6%
21	492224	2.0%
1	454534	1.8%
Other values (1567)	6514493	26.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-156	1	< 0.1%
-63	2	< 0.1%
-60	1	< 0.1%
-54	2	< 0.1%
-52.5	2	< 0.1%
-48	2	< 0.1%
-45	1	< 0.1%
-36	5	< 0.1%
-31.5	2	< 0.1%
-27	2	< 0.1%

Value	Count	Frequency (%)
15000	2	< 0.1%
13200	4	< 0.1%
11880	1	< 0.1%
11812.5	1	< 0.1%
11340	1	< 0.1%
11124	1	< 0.1%
8964	1	< 0.1%
8736	1	< 0.1%
8505	1	< 0.1%
8032.5	1	< 0.1%

Volume Sold (Gallons)
Real number (ℝ)

SKEWED

Distinct	1875
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.4208059

Minimum	-41.21
Maximum	3962.58
Zeros	465
Zeros (%)	< 0.1%
Negative	400
Negative (%)	< 0.1%
Memory size	189.6 MiB

Quantile statistics

Minimum	-41.21
5-th percentile	0.13
Q1	0.4
median	1.27
Q3	2.77
95-th percentile	5.55
Maximum	3962.58
Range	4003.79
Interquartile range (IQR)	2.37

Descriptive statistics

Standard deviation	9.3282946
Coefficient of variation (CV)	3.8533839
Kurtosis	12528.031
Mean	2.4208059
Median Absolute Deviation (MAD)	1.1
Skewness	65.336529
Sum	60150929
Variance	87.01708
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2.77	3207479	12.9%
2.38	2745687	11.1%
2.37	2066613	8.3%
0.59	1720122	6.9%
3.17	1456459	5.9%
0.4	1279070	5.1%
0.79	1147574	4.6%
0.2	889135	3.6%
1.18	815734	3.3%
0.39	769411	3.1%
Other values (1865)	8750197	35.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-41.21	1	< 0.1%
-16.64	2	< 0.1%
-15.85	1	< 0.1%
-14.26	2	< 0.1%
-13.86	2	< 0.1%
-12.68	2	< 0.1%
-11.88	1	< 0.1%
-9.51	5	< 0.1%
-8.32	2	< 0.1%
-7.13	2	< 0.1%

Value	Count	Frequency (%)
3962.58	2	< 0.1%
3487.07	4	< 0.1%
3138.36	1	< 0.1%
3120.53	1	< 0.1%
2995.71	1	< 0.1%
2938.65	1	< 0.1%
2368.03	1	< 0.1%
2307.8	1	< 0.1%
2246.78	1	< 0.1%
2121.96	1	< 0.1%

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	Invoice/Item Number	Date	Store Number	Store Name	Address	City	Zip Code	Store Location	County Number	County	Category	Category Name	Vendor Number	Vendor Name	Item Number	Item Description	Pack	Bottle Volume (ml)	State Bottle Cost	State Bottle Retail	Bottles Sold	Sale (Dollars)	Volume Sold (Liters)	Volume Sold (Gallons)
0	INV-16589800035	12/27/2018	2600	Hy-Vee Food Store / Oskaloosa	110 S D St	Oskaloosa	52577.0	POINT (-92.649764 41.295218)	62.0	MAHASKA	1011600.0	Straight Rye Whiskies	255.0	Infinium Spirits	27102	Templeton 4YR Rye	6	750	18.09	27.14	6	162.84	4.50	1.18
1	INV-16669000029	12/31/2018	4843	Stewart Road Fast Break	2418 Stewart Rd	Muscatine	52761.0	POINT (-91.07265200000002 41.390911)	70.0	MUSCATINE	1082200.0	Imported Schnapps	421.0	SAZERAC COMPANY INC	69634	Dr McGillicuddys Cherry	24	375	5.33	8.00	2	16.00	0.75	0.19
2	INV-16624000064	12/28/2018	2593	Hy-Vee Food Store / Carroll	905 US Highway 30 West	Carroll	51401.0	POINT (-94.853591 42.064155)	14.0	CARROLL	1011300.0	Single Barrel Bourbon Whiskies	259.0	Heaven Hill Brands	18120	Evan Williams Vintage	6	750	15.47	23.21	12	278.52	9.00	2.37
3	INV-16610400055	12/28/2018	4083	Fareway Stores #909 / Ankeny	109 SE Oralabor Rd	Ankeny	50021.0	POINT (-93.59949600000002 41.702811)	77.0	POLK	1701100.0	Temporary & Specialty Packages	260.0	DIAGEO AMERICAS	77903	Smirnoff Peppermint Twist	12	750	8.25	12.38	4	49.52	3.00	0.79
4	INV-16575300022	12/27/2018	3417	Big G Food Store	Po Box 261 310 W Dillon	Marengo	52301.0	NaN	48.0	IOWA	1011600.0	Straight Rye Whiskies	255.0	Infinium Spirits	26781	Templeton Rye Rare Cask Strength	6	750	29.99	44.99	1	44.99	0.75	0.19
5	INV-16623300001	12/28/2018	4190	Fareway Stores #888 / Jefferson	1207 N Elm St	Jefferson	50129.0	POINT (-94.377667 42.026833)	37.0	GREENE	1081600.0	Whiskey Liqueur	421.0	SAZERAC COMPANY INC	64867	Fireball Cinnamon Whiskey	12	1000	11.34	17.01	12	204.12	12.00	3.17
6	INV-16615400044	12/28/2018	2627	Hy-Vee Wine & Spirits #1 / MLK	3330 Martin Luther King Jr Pkwy	Des Moines	50310.0	POINT (-93.65078800000002 41.625924)	77.0	POLK	1031100.0	American Vodkas	322.0	Prestige Wine & Spirits Group	36595	Kinky Vodka	6	1750	12.50	18.75	3	56.25	5.25	1.38
7	INV-16676400069	12/31/2018	4312	I-80 Liquor / Council Bluffs	2411 S 24TH ST #1	Council Bluffs	51501.0	POINT (-95.8792 41.238092)	78.0	POTTAWATTA	1081400.0	American Schnapps	65.0	Jim Beam Brands	82847	Dekuyper Luscious Peachtree	12	1000	7.87	11.81	24	283.44	24.00	6.34
8	INV-16638500039	12/29/2018	3443	Super Saver Iv	1141 N Broadway	Council Bluffs	51503.0	POINT (-95.836515 41.270824)	78.0	POTTAWATTA	1071100.0	Cocktails /RTD	395.0	PROXIMO	59154	1800 Ultimate Margarita	6	1750	10.04	15.06	2	30.12	3.50	0.92
9	INV-16631100032	12/29/2018	2550	Hy-Vee Food Store / Osceola	510 West Mclane	Osceola	50213.0	POINT (-93.77321 41.030569)	20.0	CLARKE	1031200.0	American Flavored Vodka	260.0	DIAGEO AMERICAS	77647	Smirnoff Citrus	12	750	8.25	12.38	3	37.14	2.25	0.59

	Invoice/Item Number	Date	Store Number	Store Name	Address	City	Zip Code	Store Location	County Number	County	Category	Category Name	Vendor Number	Vendor Name	Item Number	Item Description	Pack	Bottle Volume (ml)	State Bottle Cost	State Bottle Retail	Bottles Sold	Sale (Dollars)	Volume Sold (Liters)	Volume Sold (Gallons)
24847471	INV-16595600030	12/27/2018	5335	Expo Liquor	1810 State Street	Bettendorf	52722.0	POINT (-90.506775 41.525308)	82.0	SCOTT	1022200.0	100% Agave Tequila	65.0	Jim Beam Brands	88548	Hornitos Plata	12	750	12.50	18.75	3	56.25	2.25	0.59
24847472	INV-16591100010	12/27/2018	5374	Iowa Liquor & Tobacco	1021 East Main Street	Ottumwa	52501.0	POINT (-92.400704 41.010404)	90.0	WAPELLO	1031100.0	American Vodkas	434.0	LUXCO INC	36308	Hawkeye Vodka	6	1750	7.17	10.76	6	64.56	10.50	2.77
24847473	INV-16610000096	12/28/2018	5425	Spirits Liquor	109 E 1st St. # B	Grimes	50111.0	POINT (-93.793812 41.68840000000001)	77.0	POLK	1082000.0	Imported Cordials & Liqueurs	192.0	Mast-Jagermeister US, Inc	65256	Jagermeister Liqueur	12	750	12.45	18.68	3	56.04	2.25	0.59
24847474	INV-16565600014	12/26/2018	4902	Broadway Liquor	821 Broadway St	Waterloo	50703.0	POINT (-92.345144 42.513772)	7.0	BLACK HAWK	1052100.0	Imported Brandies	420.0	MOET HENNESSY USA	48105	Hennessy VS	12	375	10.49	15.74	12	188.88	4.50	1.18
24847475	INV-16598300127	12/27/2018	3820	Charlie's Wine and Spirits,	507 W 19th St	Sioux City	51103.0	POINT (-96.420193 42.510535)	97.0	WOODBURY	1032200.0	Imported Flavored Vodka	65.0	Jim Beam Brands	35628	Pinnacle Whipped	6	1750	12.59	18.89	2	37.78	3.50	0.92
24847476	INV-16674500027	12/31/2018	2650	Hy-Vee Wine and Spirits / Harlan	1808 23rd St	Harlan	51537.0	POINT (-95.339881 41.650658)	83.0	SHELBY	1012100.0	Canadian Whiskies	260.0	DIAGEO AMERICAS	10808	Crown Royal Regal Apple	12	1000	18.89	28.34	12	340.08	12.00	3.17
24847477	INV-16619100046	12/28/2018	3528	Super Target T-0804 Mason City	3450 4th St SW	Mason City	50401.0	POINT (-93.250371 43.148393)	17.0	CERRO GORD	1081600.0	Whiskey Liqueur	421.0	SAZERAC COMPANY INC	64866	Fireball Cinnamon Whiskey	12	750	9.00	13.50	12	162.00	9.00	2.37
24847478	INV-16582300045	12/27/2018	3622	Wal-Mart 1415 / Spirit Lake	2600 Hwy 71	Spirit Lake	51360.0	POINT (-95.126535 43.416452)	30.0	DICKINSON	1032200.0	Imported Flavored Vodka	370.0	PERNOD RICARD USA	33467	Absolut Lime	12	750	11.49	17.24	12	206.88	9.00	2.37
24847479	INV-16608200035	12/28/2018	4959	Bani's	2128 College St	Cedar Falls	50613.0	POINT (-92.455801 42.518018000000005)	7.0	BLACK HAWK	1062500.0	Flavored Rum	370.0	PERNOD RICARD USA	42712	Malibu Coconut Rum Mini	12	500	4.95	7.43	2	14.86	1.00	0.26
24847480	INV-16619600095	12/28/2018	2515	Hy-Vee Food Store #1 / Mason City	2400 4th St SW	Mason City	50401.0	POINT (-93.23551 43.149557)	17.0	CERRO GORD	1022200.0	100% Agave Tequila	260.0	DIAGEO AMERICAS	89164	Don Julio 1942	6	750	64.99	97.49	1	97.49	0.75	0.19

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks